package com.aviation.sell_ticket.mapper;

import com.aviation.sell_ticket.pojo.Aviation_flight_sequence;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface FlightSequenceMapper {

    @Select("select flight_one,flight_two,flight_three,flight_four,flight_one_time,transfer from aviation_flight_sequence where order_id=#{orderId}")
    public Aviation_flight_sequence sequenceQuery(@Param("orderId") String orderId);

    @Insert("insert into aviation_flight_sequence values(#{sequence.sequence},#{sequence.flight_one},#{sequence.flight_two},#{sequence.flight_three},#{sequence.flight_four},#{sequence.flight_one_time},#{sequence.transfer},#{sequence.order_id})")
    public int sequenceAdd(@Param("sequence") Aviation_flight_sequence sequence);

}
